In SAS Enterprise Guide 4.2, the Import Data Task might be slower than in previous versions. This issue will most likely occur for Microsoft Excel and Microsoft Access files. For example, a data file that is about 25 MB with 30 columns and 55,000 rows might take two hours to import.

To circumvent this performance problem, use Excel to save the file in .csv format, and then use SAS Enterprise Guide to import the .csv file instead of the .xls/x file.

An alternative circumvention is to follow these steps:

1. Close SAS Enterprise Guide.
2. Go to the path were SAS Enterprise Guide 4.2 is installed. By default the path is C:\Program Files\SAS\EnterpriseGuide\4.2.
3. Open the file named seguide.exe.config in a text editor.
4. Locate the block of code starting with <appSettings> and ending with </appSettings>.
5. Insert this line inside the block of code: <add key="ImportDataIgnoreOffice" value="1"/>

The resulting block of code will look something like this:

<appSettings> <add key="ImportDataIgnoreOffice" value="1"/> </appSettings>

Operating System and Release Information